//---------------------------------------------------------------------------

#ifndef uProcH
#define uProcH
//---------------------------------------------------------------------------
#include <Classes.hpp>
#include <Controls.hpp>
#include <StdCtrls.hpp>
#include <Forms.hpp>
#include "DBAccess.hpp"
#include "IBC.hpp"
#include "MemDS.hpp"
#include <DB.hpp>
//---------------------------------------------------------------------------
class TdmProc : public TDataModule
{
__published:	// IDE-managed Components
	TIBCQuery *dsetTEK_MONTH;
	TIBCDataSource *dsTEK_MONTH;
	TIBCQuery *dsetBRON;
	TIBCDataSource *dsBRON;
	TIBCQuery *dsetGEU;
	TIBCDataSource *dsGEU;
	TIBCQuery *dsetKONTR;
	TIBCDataSource *dsKONTR;
	TIBCQuery *dsetSPR;
	TIBCDataSource *dsSPR;
	TIBCQuery *dsetMNOGOET;
	TIBCDataSource *dsMNOGOET;
	TIBCDataSource *dsVID_GAZA;
	TIBCQuery *dsetVID_GAZA;
	TIBCQuery *dsetKOL_PRIB;
	TIBCDataSource *dsKOL_PRIB;
	TIBCQuery *dsetVID_RASH;
	TIBCDataSource *dsVID_RASH;
	TIBCQuery *dsetTarif;
	TIBCDataSource *dsTarif;
	TIBCQuery *dsetGOR_VOD;
	TIBCDataSource *dsGOR_VOD;
	TIBCQuery *dsetINF_OPLATA;
	TIBCDataSource *dsINF_OPLATA;
	TIBCDataSource *dsNORM_TEK;
	TIBCQuery *dsetNORM_TEK;
	TIBCQuery *dsetOTKL_PRIB;
	TIBCDataSource *dsOTKL_PRIB;
	TIBCDataSource *dsSTAT_POV;
	TIBCQuery *dsetSTAT_POV;
	TIBCQuery *dsetCOUNTER;
	TIBCDataSource *dsCOUNTER;
	TIBCQuery *dsetF_PRIB;
	TIBCDataSource *dsF_PRIB;
	TIBCQuery *dsetMESTO;
	TIBCDataSource *dsMESTO;
	TIBCQuery *dsetTO;
	TIBCDataSource *dsTO;
	TIBCQuery *dsetISPOLN;
	TIBCDataSource *dsISPOLN;
	TIBCQuery *dsetPRITH_OTKL;
	TIBCDataSource *dsPRITH_OTKL;
	TIBCQuery *dsetSPOSOB_OTKL;
	TIBCDataSource *dsSPOSOB_OTKL;
	TIBCQuery *dsetSOTR;
	TIBCDataSource *dsSOTR;
	TIBCQuery *dsetF_OTKL_PRIB;
	TIBCDataSource *dsF_OTKL_PRIB;
	TIBCQuery *dsetSPR_GILZI;
	TIBCDataSource *dsSPR_GILZI;
	TIBCQuery *dsetSPR_LG;
	TIBCDataSource *dsSPR_LG;
	TIBCQuery *dsetABON_LG;
	TIBCDataSource *dsABON_LG;
	TIBCQuery *dsetPROSM_PER;
	TIBCDataSource *dsPROSM_PER;
	TIBCQuery *dsetSPOSOB_SN;
	TIBCDataSource *dsSPOSOB_SN;
	TIBCQuery *dsetNAIM_VOZD;
	TIBCDataSource *dsNAIM_VOZD;
	TIBCQuery *dsetVID_VOZD;
	TIBCDataSource *dsVID_VOZD;
	TIBCQuery *dsetPROSM_POV;
	TIBCDataSource *dsPROSM_POV;
	TIBCQuery *dsetVID_BRON;
	TIBCDataSource *dsVID_BRON;
	TIBCQuery *dsetPROV_NA_LG;
	TIBCDataSource *dsPROV_NA_LG;
	TIBCQuery *dsetEdIzm;
	TIBCDataSource *dsEdIzm;
	TIBCQuery *dsetSPR_HAR_JOB;
	TIBCDataSource *dsSPR_HAR_JOB;
	TIBCQuery *dsetVID_JOB;
	TIBCDataSource *dsVID_JOB;
	TIBCDataSource *dsSPR_JOB;
	TIBCQuery *dsetSPR_JOB;
	TIBCQuery *dsetSOTR_VDGO;
	TIBCDataSource *dsSOTR_VDGO;
	TIBCQuery *dsetDOLGN;
	TIBCDataSource *dsDOLGN;
	TIBCQuery *dsetPROSM_LIC;
	TIBCDataSource *dsPROSM_LIC;
	TIBCQuery *dsetPROV_GILZI;
	TIBCDataSource *dsPROV_GILZI;
	TIBCQuery *dsetTIP_JOB;
	TIBCDataSource *dsTIP_JOB;
	TIBCQuery *dsetSTATUS_ZAYVKI;
	TIBCDataSource *dsSTATUS_ZAYVKI;
	TIBCQuery *dsetOTOP_PERIOD;
	TIBCDataSource *dsOTOP_PERIOD;
	TIBCQuery *dsetZAP_POK_CSH;
	TIBCDataSource *dsZAP_POK_CSH;
	TIBCQuery *dsetPRITH_PERESH;
	TIBCDataSource *dsPRITH_PERESH;
	TIBCQuery *dsetMARKA;
	TIBCDataSource *dsMARKA;
	TIBCQuery *dsetMODEL;
	TIBCDataSource *dsMODEL;
	TIBCQuery *dsetRASH_PO_SCH;
	TIBCDataSource *dsRASH_PO_SCH;
	TIBCQuery *dsetOTKL_SCH;
	TIBCDataSource *dsOTKL_SCH;
	TIBCQuery *dsetZAP_POK_LIC;
	TIBCDataSource *dsZAP_POK_LIC;
private:	// User declarations
public:		// User declarations
	__fastcall TdmProc(TComponent* Owner);
	void __fastcall TdmProc::TEK_MONTH(int NOM);
	void __fastcall TdmProc::KOL_VYB(int NOM, String DAT);
	void __fastcall TdmProc::SPISOK_GEU();
	void __fastcall TdmProc::SPISKOK_KONTR();
	void __fastcall TdmProc::SPISOK_MNOGOETAG(int KOD_GEU);
	void __fastcall TdmProc::SPISOK_VID_GAZA();
	void __fastcall TdmProc::SPISOK_VID_RASH();
	void __fastcall TdmProc::SPISOK_TARIF(int VID_GAZA, int VID_RASH);
	void __fastcall TdmProc::SPISOK_MESTO();
	void __fastcall TdmProc::SPISOK_TO();
	void __fastcall TdmProc::SPISOK_ISPOLN();
	void __fastcall TdmProc::SPISOK_PRITH_OTKL();
	void __fastcall TdmProc::SPISOK_SPOSOB_OTKL();
	void __fastcall TdmProc::SPISOK_SOTR();
	void __fastcall TdmProc::SPISOK_GOR_VODA(int TARIF);
	void __fastcall TdmProc::SPISOK_GILZOV(int NOM);
	void __fastcall TdmProc::SPISOK_ED_IZM();
	void __fastcall TdmProc::SPISOK_SPOSOB_SN();
	void __fastcall TdmProc::SPISOK_MERI_VOZD();
	void __fastcall TdmProc::SPISOK_VID_VOZD();
	void __fastcall TdmProc::SPISOK_VID_BRON();
	void __fastcall TdmProc::SPISOK_VID_JOB();
	void __fastcall TdmProc::SPISOK_DOLGNOSTI();
	void __fastcall TdmProc::SPISOK_TIP_JOB();
	void __fastcall TdmProc::SPISOK_STATUS_ZAYVKI();
	void __fastcall TdmProc::SPISOK_PRITN_PERESH();
	void __fastcall TdmProc::SPISOK_MARKA(int TIP);
	void __fastcall TdmProc::SPISOK_MODEL(int TIP,String MARKA);
	void __fastcall TdmProc::KOL_PRIB(int NOM);
	void __fastcall TdmProc::ZAP_CB(String POLE_ONE, String POLE_TWO, String table);
	void __fastcall TdmProc::INF_OPLATA(int NOM);
	void __fastcall TdmProc::NATH_OPL_PO_ABON(int NOM);
	void __fastcall TdmProc::SCHETHIK(int NOM);
	void __fastcall TdmProc::F_PRIB(int NOM);
	void __fastcall TdmProc::F_OTKL_PRIB(int NOM);
	void __fastcall TdmProc::SPR_LGOT();
	void __fastcall TdmProc::ABON_LG(int NOM);
	void __fastcall TdmProc::PROSM_PERESH(int STAT_PER,int NOM,String MES, String GOD);
	void __fastcall TdmProc::PROSM_POVERKI(int NOM);
	void __fastcall TdmProc::KOL_JIL_LG(int NOM);
	void __fastcall TdmProc::HAR_JOB();
	void __fastcall TdmProc::SPR_JOB();
	void __fastcall TdmProc::SPR_SOTR_VDGO();
	void __fastcall TdmProc::PROSM_LIC(int NOM);
	void __fastcall TdmProc::PEREVOD(int TARIF, int NOM, int NEW_PRIZ,TDateTime DAT);
	void __fastcall TdmProc::UST_TARIF(int NOM, int TARIF, int PRIZ,int STAT);
	void __fastcall TdmProc::OTKL_PRIB(int TARIF, int NOM, TDateTime DAT,int TIP,
	int POK_NATH,int POK_KON, int PRITH,int SOTR,int PRITH_ZAM,TDateTime DAT_ZAM);
	void __fastcall TdmProc::PODKL_PRIB(int TARIF, int NOM,String PRIB,TDateTime DAT);
	void __fastcall TdmProc::NAIM_KLSF_PO_KOD(int KOD);
	void __fastcall TdmProc::ABON_PO_KODY_Z(int KOD_Z);
	void __fastcall TdmProc::INF_PO_PRIB(int TIP);
	void __fastcall TdmProc::POISK_KART(int STAT,int VID_POISK,int REFR);
	void __fastcall TdmProc::INF_PEREVOD(int NOM);
	void __fastcall TdmProc::OTOP_PERIOD();
	void __fastcall TdmProc::RASH_PO_SCH(int NOM,String MES,String GOD,int V1, int V2);
  void __fastcall TdmProc::ZAP_POK_CSH(int NOM, int NATH_POK, int KON_POK,
	int KOL_GAZ, String MES, String GOD);
	void __fastcall TdmProc::PROSM_POK_SCH(int NOM);
	void __fastcall TdmProc::ZAP_NATH(int NOM,String GOD,String MES,int TARIF,int KOL_VYB,
	int LG_VYB,int KOL_BRON,int LG_BRON,int PRIZ,float SUMN,float SUM_,float SUM_LG,
	float CENA1,float CENA2,int DEN_TRF,float SUM_BR,float SUM_VYB,
	int KOL_JIL, int KOL_LG,int KOD_GAZ,int PROC_LG,int KW_METR,
	int NATH_POK,int KON_POK,int KOL_GAZ,int REDAKT);
	void __fastcall TdmProc::ZAP_POK_LICEV(int NOM, int POK_SCH);
	int  __fastcall TdmProc::PROV_NA_SCH(int NOM);
	int __fastcall TdmProc::NORMA(int NOM);
	int __fastcall TdmProc::OTKL_PRIB(int NOM);
	int __fastcall TdmProc::STATUS_POV(int NOM);
	int __fastcall TdmProc::MaxNom(String Tabl, String Pole);
	int __fastcall TdmProc::ProverkaPrib(int NOM, int TARIF,int KART);
	int __fastcall TdmProc::KOL_POV(int NOM);
	int __fastcall TdmProc::PROVERKA_NA_LG(int KOD_GILZA, int NOM);
	int __fastcall TdmProc::MAX_KOD_KLSFCT(int KOD);
	int __fastcall TdmProc::PROV_SPR_GILZI(String FIO);
	int __fastcall TdmProc::PROC(int NOM);
	int __fastcall TdmProc::TARIF(int NOM);
	int __fastcall TdmProc::VID_RASH(int NOM);
	int __fastcall TdmProc::KOL_ZAY_PO_SOTR(int SOTR, int STATUS,TDateTime DAT);
	int __fastcall TdmProc::RASH_TRF(int NOM,String GOD, String MES,
	int STAT, String NATH_INT, String KON_INT,int PROSM);
	int __fastcall TdmProc::KOD_PRIBORA(int TIP,String MARKA,String MODEL);
	int __fastcall TdmProc::KOD_PRIB_PO_NOM(int TIP,int NOM);
	String __fastcall TdmProc::GOR_VOD(int KOD_TARIF);
	String __fastcall TdmProc::DATA_PLUS_GOD(String DATA,int KOL_GOD);
	String __fastcall TdmProc::NAIM_KL(int KOD,int KOD_HC);
	String __fastcall TdmProc::NAIM_VID_OPL(int KOD_HC);
	String __fastcall TdmProc::NaimTarif(int KOD_TF);
	String __fastcall TdmProc::NATH_RASH_PERIOD();
};
//---------------------------------------------------------------------------
extern PACKAGE TdmProc *dmProc;
//---------------------------------------------------------------------------
#endif
